dataSource {
      pooled = true
      driverClassName = "com.mysql.jdbc.Driver"
      username = "root"
      password = "011001"
      dialect = 'org.hibernate.dialect.MySQL5InnoDBDialect'
      properties {
            maxActive = 50
            maxIdle = 25
            minIdle = 5
            initialSize = 5
            minEvictableIdleTimeMillis = 60000
            timeBetweenEvictionRunsMillis = 60000
            maxWait = 10000
            validationQuery = "/* ping */"
      }
}

hibernate {
      cache.use_second_level_cache = true
      cache.use_query_cache = true
      cache.provider_class = 'net.sf.ehcache.hibernate.EhCacheProvider'
}

// environment specific settings
environments {
      development {
            dataSource {
                  dbCreate = "update"
                  url = "jdbc:mysql://localhost:3306/designoAPP"
            }
      }
      test {
            dataSource {
                  dbCreate = "update"
                  url = "jdbc:mysql://localhost:3306/designoAPP"
            }
      }
      production {
            dataSource {
              
                  username = "designod_designo"
                  password = "designo011001"
                  dbCreate = "update"
                  url = "jdbc:mysql://localhost/designod_designo"
            }
      }
}